package com.yeraphael.mapper;


import com.yeraphael.entity.Dept;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface DeptMapper {
    /**
     * 查询部门列表
     * @return
     */
    // 数据封装方式一：手动结果映射
//     @Results({
//             @Result(column = "create_time", property = "createTime"),
//             @Result(column = "update_time", property = "updateTime")
//     })

    // 数据封装方式二：起别名
    // @Select("select id, name, create_time createTime, update_time updateTime from dept")

    // 数据封装方式三：全局配置，开启驼峰命名规则映射
//    @Select("select * from dept")
    public List<Dept> list();
    public Dept get(Integer id);


    @Delete("delete from dept where id = #{id}")
    public void delete(Integer id);

    @Insert("insert into dept values (#{name}, #{createTime}, #{updateTime})")
    void insert(Dept dept);

    @Select("select * from dept where id = #{id}")
    Dept selectByid(Integer id);

//    @Update("update dept set name = #{name}, update_time = #{updateTime} where id = #{id}")
    void update(Dept dept);
}
